<?
	session_start();
	require("checksessionadmin.php");
	require("connect.php");	
?>
<html><!-- InstanceBegin template="/Templates/admintemplate.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<script language="Javascript" src="../scripts/innovaeditor.js"></script>
<link rel="stylesheet" type="text/css" href="../css/engine.css" />
<!-- InstanceBeginEditable name="head" -->
<!-- InstanceEndEditable -->
<script language="javascript" type="text/javascript" src="../js/datetimepicker.js">
</script>
</head>
<body>
<table align="center" width="960px" cellpadding="0" cellspacing="0" border="0">
<tr><td colspan="2" height="124" valign="top" align="center">
	<object classid="clsidsmilie27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="960" height="124" align="absmiddle">
   <param name="movie" value="flash/banneradmin.swf" />
   <param name="quality" value="high" />
   <embed src="../flash/banneradmin.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="960" height="124" align="absmiddle"></embed>
 	</object>
</td></tr>
<tr><td colspan="2" height="34">	
	<div id="menuadmin">
		<ul id="p7menubar">
			 <li><a class="trigger" href="index.php" target="_self">Trang chủ admin</a></li>
			 <li class="linemenus"></li>					 
		 	 <li><a class="trigger" href="../index.php" target="_self">Trang chủ trường</a>									  	
		  	<li class="linemenus"></li>					 
		  	<li><a class="trigger" href="thongtincanhanadmin.php" target="_self">Thông tin cá nhân</a>			
			<li class="linemenus"></li>					 
		  	<li><a class="trigger" href="../logout.php" target="_self">Thoát</a>	
			<li class="linemenus"></li>	
			<li><a class="trigger">							
				<?
				$nguoidung=$_SESSION["username"];
				if($_SESSION["quyen"]==0){
				$resu23=mysql_query("select * from admin where maadmin='{$nguoidung}'");
				$row23=mysql_fetch_array($resu23);
				?>
					<font color="#FFFFFF">			 
					<? echo "Xin chào : ".$row23["hotendem"]."&nbsp;".$row23["ten"]; ?>
					</font>
				<? }?>	
			</a>							
		  <!--het-->
		</ul>
	</div>	
	</td>
</tr>
<tr>
<td valign="top" align="left" height="750" width="180">
	<!--menu trai-->
		<table align="center" width="100%" border="1" cellpadding="0" cellspacing="0">
		<tr><td valign="middle" height="30">
			<a href="tintuc_admin.php"><img src="../anh/tintuc.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="tintuc_admin.php">Quản lý tin tức</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="loaitin_admin.php"><img src="../anh/loaitin.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="loaitin_admin.php">Quản lý loại tin</a>
		</td></tr>		
		<tr><td valign="middle" height="30">
				<a href="lopctn_admin.php"><img src="../anh/lopctn.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="lopctn_admin.php">Quản lý lớp</a>
		</td></tr>
		
		<tr><td valign="middle" height="30">
			<a href="tobomon_admin.php"><img src="../anh/tobomon.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="tobomon_admin.php">Quản lý tổ giáo viên</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="giaovien_admin.php"><img src="../anh/giaovien.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="giaovien_admin.php">Quản lý giáo viên</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="phuhuynh_admin.php"><img src="../anh/phuhuynh.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="phuhuynh_admin.php">Quản lý phụ huynh</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="hocsinh_admin_1.php"><img src="../anh/user.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="hocsinh_admin_1.php">Quản lý học sinh</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="thoikhoabieu_admin.php"><img src="../anh/thoikhoabieu.png" height="16" width="15" border="0">&nbsp;&nbsp;</a><a href="thoikhoabieu_admin.php">Quản lý thời khóa biểu</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="baiviet_admin.php"><img src="../anh/baiviet.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="baiviet_admin.php">Quản lý bài viết</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="monhoc_admin.php"><img src="../anh/monhoc.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="monhoc_admin.php">Quản lý môn học</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="tailieu_admin.php"><img src="../anh/tailieu.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="tailieu_admin.php">Quản lý tài liệu</a>
		</td></tr>
		<?
			$menu=$_REQUEST["opt"];
			if(($menu=="")||($menu==ko)){
		?>
			<tr><td valign="middle" height="30">
				<a href="?opt=co"><img src="../anh/thuvienanh.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="?opt=co">Quản lý thư viện ảnh</a>
			</td></tr>
		<? }else if($menu==co){?>
			<tr><td valign="middle" height="30">
				<a href="?opt=ko"><img src="../anh/thuvienanh.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="?opt=ko">Quản lý thư viện ảnh</a><br>
				&nbsp;<a href="thuvienanh_admin.php">
					<img src="../anh/1px.gif" height="15" width="16" border="0">
				</a><a href="thuvienanh_admin.php">Thư viện ảnh trường</a><br>
				&nbsp;<a href="thuvienanhlop_admin.php">
					<img src="../anh/1px.gif" height="15" width="16" border="0">
				</a><a href="thuvienanhlop_admin.php">Thư viện ảnh lớp</a>
			</td></tr>
		<? }?>
		
		<tr><td valign="middle" height="30">
			<a href="khoahoc_admin.php"><img src="../anh/khoahoc.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="khoahoc_admin.php">Quản lý khóa học</a>
		</td></tr>
		<!--
		<tr><td valign="middle" height="30">
			<a href="admin_admin.php"><img src="../anh/admin.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="admin_admin.php">Quản lý account</a>
		</td></tr>	
		-->
		<tr><td valign="middle" height="30">
			<a href="admin_sodaubai.php"><img src="../anh/sodaubai.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="sodaubai_admin.php">Quản lý sổ ghi đầu bài</a>
		</td></tr>
		<tr><td valign="middle" height="30">
			<a href="admin_lienket.php"><img src="../anh/lienket.png" height="16" width="16" border="0">&nbsp;&nbsp;</a><a href="lienket_admin.php">Quản lý menu</a>
		</td></tr>		
		</table>
</td>
<!--Het menu trai-->
    <td valign="top" align="center"><!-- InstanceBeginEditable name="EditRegion3" -->
	<?
	$mal=$_REQUEST["mal"];
	$result2=mysql_query("select * from lop where mal='{$mal}'");
	$r2=mysql_fetch_array($result2);
	$ngay=$_REQUEST["ngay"];
	$result=mysql_query("select * from sodaubai where mal='{$mal}' and ngay='{$ngay}' order by tiethoc");	
	?>
	<h3 align="center"><font color="#CC3333">Quản lý sổ ghi đầu bài</font> </h3>		
	<div class="paneladmin">
			<div class="paneladmin_header"><font color="#003366">Sổ ghi đầu bài lớp <? echo $r2["tenl"];?> ngày <? echo $ngay;?></font></div>
			<table align="center" cellpadding="4" cellspacing="0" border="0" width="98%">
							<? while($r=mysql_fetch_array($result)){?>
								<tr><th colspan="2" align="left"><font color="#CC3333">Tiết <? echo $r["tiethoc"];?></font></th></tr>									
								<tr>															
								<th align="left" width="180px">Môn học	:</th>
								<td><?	
									$result2=mysql_query("select * from monhoc where mamh='{$r["mamh"]}'");
									if(mysql_num_rows($result2)<=0)
									{
										echo $r["mamh"];
									}else {
										$r2=mysql_fetch_array($result2);
										echo $r2["tenmh"];
									}
							?></td>
						</tr>						
						<tr>
								<th align="left">Bài học :</th>
								<td><? echo $r["baihoc"];?></td>
						</tr>																	
						<tr>
							<th align="left">Nhận xét của giáo viên :</th>
							<td><? echo $r["nhanxet"];?></td>
						</tr>
						<tr>
							<th align="left">Sĩ số :</th>
							<td><?
								$result6=mysql_query("select * from hocsinh where mal='{$r["mal"]}'");
								$n=mysql_num_rows($result6);
								$n1=$n-$r["hsvang"];
								echo $n1;echo " / ";echo $n;echo " học sinh"
							?></td>
						</tr>						
						<tr>
							<th align="left">Học sinh vắng :</th>
							<td>
								<?
									$result3=mysql_query("select * from hocsinh where mal='{$r["mal"]}'");
									while($r3=mysql_fetch_array($result3)){
										$result4=mysql_query("select * from chuyencan where mahs='{$r3["mahs"]}' and ngay='{$r["ngay"]}' and tiet='{$r["tiethoc"]}' and chuyencan!=3");
										while($r4=mysql_fetch_array($result4)){
											$result5=mysql_query("select * from hocsinh where mahs='{$r4["mahs"]}'");
											if(mysql_num_rows($result5)<=0)
											{
												echo $r4["mahs"];
												echo ",&nbsp;";
											}else {
											$r5=mysql_fetch_array($result5);
												echo $r5["hotendem"];echo "&nbsp;";echo $r5["ten"];
												echo ",&nbsp;";
											}
										}
									}
								?>
							</td>
						</tr>
						<tr>
							<th align="left">Xếp loại :</th>
							<td>
								<?								
									if($r["xeploai"]==1)
									{  
										echo "Tốt";
									}else if($r["xeploai"]==2)
									{  
										echo "Khá";
									}else if($r["xeploai"]==3)
									{  
										echo "Trung bình";
									}else if($r["xeploai"]==4)
									{  
										echo "Yếu";
									}else if($r["xeploai"]==5)
									{
										echo "Kém";
									}
								?>
							</td>
						</tr>							
						<tr>
								<th align="left">Giáo viên :</th>						
								<td><?
									$result1=mysql_query("select * from giaovien where magv='{$r["magv"]}'");
									$r1=mysql_fetch_array($result1);
									echo $r1["hotendem"];echo "&nbsp;";echo $r1["ten"];
								?></td>
						</tr>					
							<? }?>
						</table>
			
	</div>	
	  		
<!-- InstanceEndEditable --></td>
</tr>
<tr><td colspan="2" height="100" valign="middle" align="center" bgcolor="#999999">Phạm Đức Đóa - Khoa CNTT - Đại học Xây Dựng</td></tr>
</table>
</body>
<!-- InstanceEnd --></html>
